package com.panasonic.cn.cmsc;

import java.io.*;
import java.lang.*;
import java.util.*;
import java.math.*;
import java.sql.SQLException;
import com.fujitsu.fks.jaaf.core.*;

public class SQLMM0599{
	private Hashtable paramsString     = new Hashtable();
	private Hashtable paramsBigDecimal = new Hashtable();
	private Hashtable paramsFree       = new Hashtable();
	private String lastSql_ = null;

	private String getString(String name){
		if(name==null) return "";
		String returnStr = (String)paramsString.get(name);
		if(returnStr==null) return "";
		return "'"+FrameworkCommon.stringReplaceSQuote(returnStr)+"'";
	}

	private String getBigDecimal(String name){
		if(name==null) return "";
		BigDecimal returnStr = (BigDecimal)paramsBigDecimal.get(name);
		if(returnStr==null) return "";
		return returnStr.toString();
	}

	private String getFree(String name){
		if(name==null) return "";
		String returnStr = (String)paramsFree.get(name);
		if(returnStr==null) return "";
		return returnStr;
	}

	public String getLastSql(){
		return lastSql_;
	}

	public int INSERT_M0501(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("	    INSERT INTO ");
		sql.append("	    M05");
		sql.append("	    (");
		sql.append("	    SLCP_CD,");
		sql.append("	    CUS_CD,");
		sql.append("	    ITM_NO,");
		sql.append("	    APL_BDT,");
		sql.append("	    APL_EDT,");
		sql.append("	    GNR_ADM_NO,");
		sql.append("	    SLS_PRIZ,");
		sql.append("	    CUS_PRC_TAB_CN,");
		sql.append("	    RGS_DTTM,");
		sql.append("	    RGS_CHRG_CD,");
		sql.append("	    RGS_PGID,");
		sql.append("	    UPD_DTTM,");
		sql.append("	    UPD_CHRG_CD,");
		sql.append("	    UPD_PGID,");
		sql.append("   	    FM_TYP");
		sql.append("	    )");
		sql.append("	    VALUES");
		sql.append("	    (");
		sql.append("	    "+getString("SLCP_CD")+",");
		sql.append("	    "+getString("CUS_CD")+",");
		sql.append("	    "+getString("ITM_NO")+",");
		sql.append("	    "+getString("APL_BDT")+",");
		sql.append("	    "+getString("APL_EDT")+",");
		sql.append("	    "+getString("GNR_ADM_NO")+",");
		sql.append("	    "+getBigDecimal("SLS_PRIZ")+",");
		sql.append("	    "+getString("CUS_PRC_TAB_CN")+",");
		sql.append("	    TO_DATE("+getString("RGS_DTTM")+",'YYYYMMDD HH24:MI:SS'), ");
		sql.append("	    "+getString("RGS_CHRG_CD")+",");
		sql.append("	    "+getString("RGS_PGID")+",");
		sql.append("	    TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDD HH24:MI:SS'),");
		sql.append("	    "+getString("UPD_CHRG_CD")+",");
		sql.append("	    "+getString("UPD_PGID")+",");
		sql.append("    	"+getString("FM_TYP")+"");
		sql.append("	    )");
		sql.append("	    ");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M0502(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("	    UPDATE");
		sql.append("	    M05");
		sql.append("	    SET");
		sql.append("	    SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+",");
		sql.append("	    CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+",");
		sql.append("	    ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+",");
		sql.append("	    APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+",");
		sql.append("	    APL_EDT "+((getString("APL_EDT").equals(""))?" is null ":"=")+getString("APL_EDT")+",");
		sql.append("	    GNR_ADM_NO "+((getString("GNR_ADM_NO").equals(""))?" is null ":"=")+getString("GNR_ADM_NO")+",");
		sql.append("	    SLS_PRIZ "+((getBigDecimal("SLS_PRIZ").equals(""))?" is null ":"=")+getBigDecimal("SLS_PRIZ")+",");
		sql.append("	    CUS_PRC_TAB_CN "+((getString("CUS_PRC_TAB_CN").equals(""))?" is null ":"=")+getString("CUS_PRC_TAB_CN")+",");
		sql.append("	    UPD_DTTM = TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDD HH24:MI:SS'),");
		sql.append("	    UPD_CHRG_CD "+((getString("UPD_CHRG_CD").equals(""))?" is null ":"=")+getString("UPD_CHRG_CD")+",");
		sql.append("	    UPD_PGID "+((getString("UPD_PGID").equals(""))?" is null ":"=")+getString("UPD_PGID")+",");
		sql.append("    	FM_TYP "+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+"");
		sql.append("	    WHERE");
		sql.append("	    SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("	    AND  ");
		sql.append("	    CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("	    AND  ");
		sql.append("	    ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("	    AND  ");
		sql.append("	    APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M0503(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		UPDATE");
		sql.append("		M05");
		sql.append("		SET");
		sql.append("		APL_EDT "+((getString("TEMP_APL").equals(""))?" is null ":"=")+getString("TEMP_APL")+",");
		sql.append("		FM_TYP "+((getString("FM").equals(""))?" is null ":"=")+getString("FM")+"");
		sql.append("		WHERE  ");
		sql.append("		SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("		AND  ");
		sql.append("		CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("		AND  ");
		sql.append("		ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("		AND  ");
		sql.append("		APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		sql.append("		");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M0504(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		 UPDATE");
		sql.append("		  M05");
		sql.append("		  SET");
		sql.append("		  APL_BDT "+((getString("TEMP_APL").equals(""))?" is null ":"=")+getString("TEMP_APL")+",");
		sql.append("		  FM_TYP "+((getString("FM").equals(""))?" is null ":"=")+getString("FM")+"");
		sql.append("		  WHERE  ");
		sql.append("		  SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("		  AND");
		sql.append("		  CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("		  AND  ");
		sql.append("		  ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("		  AND  ");
		sql.append("		  APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"   ");
		sql.append("		");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M0505(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		 UPDATE");
		sql.append("		M05 ");
		sql.append("		SET");
		sql.append("		FM_TYP "+((getString("FM").equals(""))?" is null ":"=")+getString("FM")+",");
		sql.append("		APL_EDT "+((getString("TEMPDATE").equals(""))?" is null ":"=")+getString("TEMPDATE")+"");
		sql.append("		WHERE  ");
		sql.append("		SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("		AND  ");
		sql.append("		CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("		AND  ");
		sql.append("		ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("		AND  ");
		sql.append("		APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		sql.append("		");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M0506(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		UPDATE");
		sql.append("		M05");
		sql.append("		SET");
		sql.append("		FM_TYP "+((getString("FM").equals(""))?" is null ":"=")+getString("FM")+"");
		sql.append("		WHERE");
		sql.append("		SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("		AND  ");
		sql.append("		CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("		AND  ");
		sql.append("		ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("		AND  ");
		sql.append("		APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public SelectResultRset SELECT_M0507(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("	   SELECT");
		sql.append("	   SLCP_CD,");
		sql.append("	   CUS_CD,");
		sql.append("	   ITM_NO,");
		sql.append("	   APL_BDT,");
		sql.append("	   APL_EDT,");
		sql.append("	   GNR_ADM_NO,");
		sql.append("	   SLS_PRIZ,");
		sql.append("	   CUS_PRC_TAB_CN,");
		sql.append("	   RGS_DTTM,");
		sql.append("	   RGS_CHRG_CD,");
		sql.append("	   RGS_PGID,");
		sql.append("	   UPD_DTTM,");
		sql.append("	   UPD_CHRG_CD,");
		sql.append("	   UPD_PGID,");
		sql.append("   	   FM_TYP");
		sql.append("	   FROM");
		sql.append("	   M05");
		sql.append("	   WHERE");
		sql.append("	   SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+"");
		sql.append("	   AND");
		sql.append("	   CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("	   AND  ");
		sql.append("	   ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("	   AND ");
		sql.append("	   APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"     ");
		sql.append("	   ");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_M0508(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		 SELECT");
		sql.append("		 SLCP_CD,");
		sql.append("		 CUS_CD,");
		sql.append("		 ITM_NO,");
		sql.append("		 APL_BDT,");
		sql.append("		 APL_EDT,");
		sql.append("		 GNR_ADM_NO,");
		sql.append("		 SLS_PRIZ,");
		sql.append("		 CUS_PRC_TAB_CN,");
		sql.append("		 RGS_DTTM,");
		sql.append("		 RGS_CHRG_CD,");
		sql.append("		 RGS_PGID,");
		sql.append("		 UPD_DTTM,");
		sql.append("		 UPD_CHRG_CD,");
		sql.append("		 UPD_PGID,");
		sql.append(" 		 FM_TYP");
		sql.append("		 FROM");
		sql.append("		 M05");
		sql.append("		 WHERE");
		sql.append("		 SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+"");
		sql.append("		 AND");
		sql.append("		 CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("		 AND  ");
		sql.append("		 ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("		 AND  ");
		sql.append("		 FM_TYP "+((getString("FM9").equals(""))?" is not null ":"!=")+getString("FM9")+"");
		sql.append("		 AND ");
		sql.append("		 FM_TYP "+((getString("FM6").equals(""))?" is not null ":"!=")+getString("FM6")+"");
		sql.append("		 ORDER BY ");
		sql.append("		 APL_BDT DESC");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_M0509(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		 SELECT");
		sql.append("		 SLCP_CD,");
		sql.append("		 CUS_CD,");
		sql.append("		 ITM_NO,");
		sql.append("		 APL_BDT,");
		sql.append("		 APL_EDT,");
		sql.append("		 GNR_ADM_NO,");
		sql.append("		 SLS_PRIZ,");
		sql.append("	   	 CUS_PRC_TAB_CN,");
		sql.append("		 RGS_DTTM,");
		sql.append("		 RGS_CHRG_CD,");
		sql.append("		 RGS_PGID,");
		sql.append("		 UPD_DTTM,");
		sql.append("		 UPD_CHRG_CD,");
		sql.append("		 UPD_PGID,");
		sql.append(" 		 FM_TYP");
		sql.append("		 FROM");
		sql.append("		 M05");
		sql.append("		 WHERE");
		sql.append("		 SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+"");
		sql.append("		 AND");
		sql.append("		 CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("		 AND  ");
		sql.append("		 ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("		 AND  ");
		sql.append("		 APL_EDT "+((getString("DATE9999").equals(""))?" is null ":"=")+getString("DATE9999")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_M0511(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		 SELECT");
		sql.append("		 SLCP_CD,");
		sql.append("		 CUS_CD,");
		sql.append("		 ITM_NO,");
		sql.append("		 APL_BDT,");
		sql.append("		 APL_EDT,");
		sql.append("		 GNR_ADM_NO,");
		sql.append("		 SLS_PRIZ,");
		sql.append("	   	 CUS_PRC_TAB_CN,");
		sql.append("		 RGS_DTTM,");
		sql.append("		 RGS_CHRG_CD,");
		sql.append("		 RGS_PGID,");
		sql.append("		 UPD_DTTM,");
		sql.append("		 UPD_CHRG_CD,");
		sql.append("		 UPD_PGID,");
		sql.append(" 		 FM_TYP");
		sql.append("		 FROM");
		sql.append("		 M05");
		sql.append("		 WHERE");
		sql.append("		 SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+"");
		sql.append("		 AND");
		sql.append("		 CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("		 AND  ");
		sql.append("		 ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("		 AND");
		sql.append("		 APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"     ");
		sql.append("		 AND");
		sql.append("		 FM_TYP "+((getString("FM").equals(""))?" is null ":"=")+getString("FM")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public int INSERT_BM0512(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		INSERT INTO");
		sql.append("		BM05");
		sql.append("		(");
		sql.append("		SEQ_NO,");
		sql.append("		 SLCP_CD,");
		sql.append("		 CUS_CD,");
		sql.append("		 ITM_NO,");
		sql.append("		 APL_BDT,");
		sql.append("		 APL_EDT,");
		sql.append("		 GNR_ADM_NO,");
		sql.append("		 SLS_PRIZ,");
		sql.append("	   	 CUS_PRC_TAB_CN,");
		sql.append("		 RGS_DTTM,");
		sql.append("		 RGS_CHRG_CD,");
		sql.append("		 RGS_PGID,");
		sql.append("		 UPD_DTTM,");
		sql.append("		 UPD_CHRG_CD,");
		sql.append("		 UPD_PGID,");
		sql.append(" 		 FM_TYP");
		sql.append("		)");
		sql.append("		SELECT");
		sql.append("		SEQ_BM05.NEXTVAL,");
		sql.append("		 SLCP_CD,");
		sql.append("		 CUS_CD,");
		sql.append("		 ITM_NO,");
		sql.append("		 APL_BDT,");
		sql.append("		 APL_EDT,");
		sql.append("		 GNR_ADM_NO,");
		sql.append("		 SLS_PRIZ,");
		sql.append("	   	 CUS_PRC_TAB_CN,");
		sql.append("		 RGS_DTTM,");
		sql.append("		 RGS_CHRG_CD,");
		sql.append("		 RGS_PGID,");
		sql.append("		 UPD_DTTM,");
		sql.append("		 UPD_CHRG_CD,");
		sql.append("		 UPD_PGID,");
		sql.append(" 		 FM_TYP");
		sql.append("		 FROM");
		sql.append("		 M05");
		sql.append("		 WHERE");
		sql.append("		 SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+"");
		sql.append("		 AND");
		sql.append("		 CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("		 AND  ");
		sql.append("		 ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("		 AND");
		sql.append("		 APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"     ");
		sql.append("		 AND");
		sql.append("		 FM_TYP "+((getString("FM").equals(""))?" is null ":"=")+getString("FM")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int DELETE_M0513(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		DELETE");
		sql.append("		FROM");
		sql.append("		M05");
		sql.append("		WHERE");
		sql.append("		 SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+"");
		sql.append("		 AND");
		sql.append("		 CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("		 AND  ");
		sql.append("		 ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("		 AND");
		sql.append("		 FM_TYP "+((getString("FM").equals(""))?" is null ":"=")+getString("FM")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int INSERT_BM0514(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		INSERT INTO");
		sql.append("		BM05");
		sql.append("		(");
		sql.append("		SEQ_NO,");
		sql.append("		SLCP_CD,");
		sql.append("		CUS_CD,");
		sql.append("		ITM_NO,");
		sql.append("		APL_BDT,");
		sql.append("		APL_EDT,");
		sql.append("		GNR_ADM_NO,");
		sql.append("		SLS_PRIZ,");
		sql.append("	   	CUS_PRC_TAB_CN,");
		sql.append("		RGS_DTTM,");
		sql.append("		RGS_CHRG_CD,");
		sql.append("		RGS_PGID,");
		sql.append("		UPD_DTTM,");
		sql.append("		UPD_CHRG_CD,");
		sql.append("		UPD_PGID,");
		sql.append("		FM_TYP");
		sql.append("		)");
		sql.append("		SELECT");
		sql.append("		SEQ_BM05.NEXTVAL,");
		sql.append("		SLCP_CD,");
		sql.append("		 CUS_CD,");
		sql.append("		 ITM_NO,");
		sql.append("		 APL_BDT,");
		sql.append("		 APL_EDT,");
		sql.append("		 GNR_ADM_NO,");
		sql.append("		 SLS_PRIZ,");
		sql.append("	   	 CUS_PRC_TAB_CN,");
		sql.append("		 RGS_DTTM,");
		sql.append("		 RGS_CHRG_CD,");
		sql.append("		 RGS_PGID,");
		sql.append("		 UPD_DTTM,");
		sql.append("		 UPD_CHRG_CD,");
		sql.append("		 UPD_PGID,");
		sql.append("		 FM_TYP");
		sql.append("		FROM		");
		sql.append("		M05");
		sql.append("		WHERE");
		sql.append("		SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+"");
		sql.append("		AND");
		sql.append("		CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+"");
		sql.append("		AND     ");
		sql.append("		ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("		AND");
		sql.append("		APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M0515(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		 UPDATE");
		sql.append("		M05 ");
		sql.append("		SET");
		sql.append("		FM_TYP "+((getString("FM8").equals(""))?" is null ":"=")+getString("FM8")+",");
		sql.append("		APL_EDT "+((getString("ENDDATE").equals(""))?" is null ":"=")+getString("ENDDATE")+"");
		sql.append("		WHERE  ");
		sql.append("		SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("		AND  ");
		sql.append("		CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("		AND  ");
		sql.append("		ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("		AND  ");
		sql.append("		APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		sql.append("		AND");
		sql.append("		FM_TYP "+((getString("FM9").equals(""))?" is null ":"=")+getString("FM9")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public SelectResultRset SELECT_M0516(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		 SELECT");
		sql.append("		 SLCP_CD,");
		sql.append("		 CUS_CD,");
		sql.append("		 ITM_NO,");
		sql.append("		 APL_BDT,");
		sql.append("		 APL_EDT,");
		sql.append("		 GNR_ADM_NO,");
		sql.append("		 SLS_PRIZ,");
		sql.append("	   	 CUS_PRC_TAB_CN,");
		sql.append("		 RGS_DTTM,");
		sql.append("		 RGS_CHRG_CD,");
		sql.append("		 RGS_PGID,");
		sql.append("		 UPD_DTTM,");
		sql.append("		 UPD_CHRG_CD,");
		sql.append("		 UPD_PGID,");
		sql.append(" 		 FM_TYP");
		sql.append("		 FROM");
		sql.append("		 M05");
		sql.append("		 WHERE");
		sql.append("		 SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+"");
		sql.append("		 AND");
		sql.append("		 CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("		 AND  ");
		sql.append("		 ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("		 AND");
		sql.append("		 FM_TYP "+((getString("FM").equals(""))?" is null ":"=")+getString("FM")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_M0517(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("	   SELECT");
		sql.append("	   SLCP_CD,");
		sql.append("	   CUS_CD,");
		sql.append("	   ITM_NO,");
		sql.append("	   APL_BDT,");
		sql.append("	   APL_EDT,");
		sql.append("	   GNR_ADM_NO,");
		sql.append("	   SLS_PRIZ,");
		sql.append("	   CUS_PRC_TAB_CN,");
		sql.append("	   RGS_DTTM,");
		sql.append("	   RGS_CHRG_CD,");
		sql.append("	   RGS_PGID,");
		sql.append("	   UPD_DTTM,");
		sql.append("	   UPD_CHRG_CD,");
		sql.append("	   UPD_PGID,");
		sql.append("   	   FM_TYP");
		sql.append("	   FROM");
		sql.append("	   M05");
		sql.append("	   WHERE");
		sql.append("	   SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+"");
		sql.append("	   AND");
		sql.append("	   CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("	   AND  ");
		sql.append("	   ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"  ");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public int INSERT_BM0518(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		INSERT INTO");
		sql.append("		BM05");
		sql.append("		(");
		sql.append("		SEQ_NO,");
		sql.append("		 SLCP_CD,");
		sql.append("		 CUS_CD,");
		sql.append("		 ITM_NO,");
		sql.append("		 APL_BDT,");
		sql.append("		 APL_EDT,");
		sql.append("		 GNR_ADM_NO,");
		sql.append("		 SLS_PRIZ,");
		sql.append("	   	 CUS_PRC_TAB_CN,");
		sql.append("		 RGS_DTTM,");
		sql.append("		 RGS_CHRG_CD,");
		sql.append("		 RGS_PGID,");
		sql.append("		 UPD_DTTM,");
		sql.append("		 UPD_CHRG_CD,");
		sql.append("		 UPD_PGID,");
		sql.append(" 		 FM_TYP");
		sql.append("		)");
		sql.append("		SELECT");
		sql.append("		SEQ_BM05.NEXTVAL,");
		sql.append("		 SLCP_CD,");
		sql.append("		 CUS_CD,");
		sql.append("		 ITM_NO,");
		sql.append("		 APL_BDT,");
		sql.append("		 APL_EDT,");
		sql.append("		 GNR_ADM_NO,");
		sql.append("		 SLS_PRIZ,");
		sql.append("	   	 CUS_PRC_TAB_CN,");
		sql.append("		 RGS_DTTM,");
		sql.append("		 RGS_CHRG_CD,");
		sql.append("		 RGS_PGID,");
		sql.append("		 UPD_DTTM,");
		sql.append("		 UPD_CHRG_CD,");
		sql.append("		 UPD_PGID,");
		sql.append(" 		 FM_TYP");
		sql.append("		 FROM");
		sql.append("		 M05");
		sql.append("		 WHERE");
		sql.append("		 SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+"");
		sql.append("		 AND");
		sql.append("		 CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("		 AND  ");
		sql.append("		 ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("		 AND");
		sql.append("		 FM_TYP "+((getString("FM").equals(""))?" is null ":"=")+getString("FM")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public SelectResultRset SELECT_M0519(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		SELECT  ");
		sql.append("		COUNT(VDR_CD) AS COUNT");
		sql.append("		FROM");
		sql.append("		M01");
		sql.append("		WHERE");
		sql.append("		VDR_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+"");
		sql.append("		AND");
		sql.append("		CTRL_DVSN_CD "+((getString("CTRL_DVSN_CD").equals(""))?" is null ":"=")+getString("CTRL_DVSN_CD")+"");
		sql.append("		AND");
		sql.append("		TRPT_CLSS_D_TYP "+((getString("TRPT_CLSS_D_TYP").equals(""))?" is null ":"=")+getString("TRPT_CLSS_D_TYP")+"");
		sql.append("		AND");
		sql.append("		APL_BDT <"+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		sql.append("		AND");
		sql.append("		FM_TYP <>  "+getString("FM6")+"");
		sql.append("		AND");
		sql.append("		FM_TYP <>  "+getString("FM9")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public int INSERT_M059901(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("INSERT INTO ");
		sql.append("M05(");
		sql.append("SLCP_CD,");
		sql.append("CUS_CD,");
		sql.append("ITM_NO,");
		sql.append("APL_BDT,");
		sql.append("APL_EDT,");
		sql.append("GNR_ADM_NO,");
		sql.append("SLS_PRIZ,");
		sql.append("CUS_PRC_TAB_CN,");
		sql.append("RGS_DTTM,");
		sql.append("RGS_CHRG_CD,");
		sql.append("RGS_PGID,");
		sql.append("UPD_DTTM,");
		sql.append("UPD_CHRG_CD,");
		sql.append("UPD_PGID, ");
		sql.append("FM_TYP");
		sql.append(")");
		sql.append("VALUES");
		sql.append("(");
		sql.append(""+getString("SLCP_CD")+",");
		sql.append(""+getString("CUS_CD")+",");
		sql.append(""+getString("ITM_NO")+",");
		sql.append(""+getString("APL_BDT")+",");
		sql.append(""+getString("APL_EDT")+",");
		sql.append(""+getString("GNR_ADM_NO")+",");
		sql.append(""+getString("SLS_PRIZ")+",");
		sql.append(""+getString("CUS_PRC_TAB_CN")+",");
		sql.append("TO_DATE("+getString("RGS_DTTM")+",'YYYYMMDD HH24:MI:SS'),");
		sql.append(""+getString("RGS_CHRG_CD")+",");
		sql.append(""+getString("RGS_PGID")+",");
		sql.append("TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDD HH24:MI:SS'),");
		sql.append(""+getString("UPD_CHRG_CD")+",");
		sql.append(""+getString("UPD_PGID")+",");
		sql.append(""+getString("FM_TYP")+"");
		sql.append(")");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public SelectResultRset SELECT_M059901(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("	SELECT");
		sql.append("	COUNT(*) AS COUNTS");
		sql.append("	FROM ");
		sql.append("	M05 ");
		sql.append("WHERE ");
		sql.append("SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("AND ");
		sql.append("CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("AND ");
		sql.append("ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("APL_BDT"+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		sql.append("	AND ");
		sql.append("	FM_TYP <> "+getString("NOT_FM_TYP")+"");
		sql.append("	"+getFree("OTHERS")+"");
		sql.append("	");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_M059902(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("	SELECT");
		sql.append("	APL_BDT");
		sql.append("	FROM ");
		sql.append("	M05 ");
		sql.append("	WHERE ");
		sql.append("	SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("	AND ");
		sql.append("	CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("	AND ");
		sql.append("	ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("	AND ");
		sql.append("	FM_TYP <> "+getString("FM_TYP_9")+"");
		sql.append("	AND ");
		sql.append("	APL_BDT = (");
		sql.append("	SELECT MAX(APL_BDT)");
		sql.append("	FROM");
		sql.append("	M05");
		sql.append("	WHERE ");
		sql.append("	SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("	AND ");
		sql.append("	CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("	AND ");
		sql.append("	ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("	AND ");
		sql.append("	FM_TYP <> "+getString("FM_TYP_6")+"");
		sql.append("	)");
		sql.append("	");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_M059903(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("SELECT ");
		sql.append("APL_BDT,");
		sql.append("APL_EDT,");
		sql.append("FM_TYP ");
		sql.append("FROM ");
		sql.append("M05 ");
		sql.append("WHERE ");
		sql.append("SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("AND ");
		sql.append("CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("AND ");
		sql.append("ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("APL_BDT"+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+" ");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_M059904(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("SELECT ");
		sql.append("COUNT(*) AS COUNTS ");
		sql.append("FROM ");
		sql.append("M05 ");
		sql.append("WHERE ");
		sql.append("SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("AND ");
		sql.append("CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("AND ");
		sql.append("ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("FM_TYP <> "+getString("NOT_FM_TYP")+"");
		sql.append("	");
		sql.append("	");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset 	SELECT_M059905(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("SELECT  ");
		sql.append("NVL( SLCP_CD,    '') AS SLCP_CD,");
		sql.append("NVL( CUS_CD,     '') AS CUS_CD,");
		sql.append("NVL( ITM_NO,     '') AS ITM_NO,");
		sql.append("NVL( APL_BDT,    '') AS APL_BDT,");
		sql.append("NVL( APL_EDT,    '') AS APL_EDT,");
		sql.append("NVL( GNR_ADM_NO, '') AS GNR_ADM_NO,");
		sql.append("NVL( SLS_PRIZ,   '') AS SLS_PRIZ,");
		sql.append("NVL( CUS_PRC_TAB_CN,   '') AS CUS_PRC_TAB_CN,");
		sql.append("NVL( RGS_DTTM,   '') AS RGS_DTTM,");
		sql.append("NVL( RGS_CHRG_CD,'') AS RGS_CHRG_CD,");
		sql.append("NVL( RGS_PGID,   '') AS RGS_PGID,");
		sql.append("TO_CHAR( UPD_DTTM,'YYYYMMDD HH24:MI:SS') AS UPD_DTTM,");
		sql.append("NVL( UPD_CHRG_CD,'') AS UPD_CHRG_CD,");
		sql.append("NVL( UPD_PGID,   '') AS UPD_PGID,  ");
		sql.append("NVL( FM_TYP,     '') AS FM_TYP       ");
		sql.append("FROM M05 ");
		sql.append("WHERE ");
		sql.append("SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("AND ");
		sql.append("CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("AND ");
		sql.append("ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("AND ");
		sql.append("FM_TYP <> "+getString("FM_TYP1")+" ");
		sql.append("AND ");
		sql.append("FM_TYP <> "+getString("FM_TYP2")+" ");
		sql.append("ORDER BY ");
		sql.append("SLCP_CD,CUS_CD,ITM_NO,APL_BDT");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public SelectResultRset SELECT_M059906(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("		SELECT  ");
		sql.append("		COUNT(ITM_NO) AS COUNT");
		sql.append("		FROM");
		sql.append("		M03");
		sql.append("		WHERE");
		sql.append("		ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("		AND");
		sql.append("		SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+"");
		sql.append("		AND");
		sql.append("		APL_BDT <"+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		sql.append("		AND");
		sql.append("		FM_TYP <>  "+getString("FM6")+"");
		sql.append("		AND");
		sql.append("		FM_TYP <>  "+getString("FM9")+" ");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}

	public int UPDATE_M059901(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("	UPDATE M05");
		sql.append("	SET");
		sql.append("	APL_EDT "+((getString("APL_EDT").equals(""))?" is null ":"=")+getString("APL_EDT")+",");
		sql.append("	UPD_DTTM = TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDDHH24MISS'),               ");
		sql.append("    UPD_CHRG_CD "+((getString("UPD_CHRG_CD").equals(""))?" is null ":"=")+getString("UPD_CHRG_CD")+",        ");
		sql.append("    UPD_PGID "+((getString("UPD_PGID").equals(""))?" is null ":"=")+getString("UPD_PGID")+",");
		sql.append("	FM_TYP "+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+"");
		sql.append("	WHERE ");
		sql.append("SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("AND ");
		sql.append("CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("AND ");
		sql.append("ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("		   AND");
		sql.append("		   APL_BDT <"+((getString("SYSDATE").equals(""))?" is null ":"=")+getString("SYSDATE")+"");
		sql.append("		   AND");
		sql.append("		   APL_EDT >"+((getString("SYSDATE").equals(""))?" is null ":"=")+getString("SYSDATE")+"");
		sql.append("		   AND FM_TYP <> "+getString("NOT_FM_TYP")+"");
		sql.append("	");
		sql.append("	   ");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M059902(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("UPDATE ");
		sql.append("M05 ");
		sql.append("SET ");
		sql.append("SLCP_CD    "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+",");
		sql.append("CUS_CD     "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+",");
		sql.append("ITM_NO     "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+",");
		sql.append("APL_BDT    "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+",");
		sql.append("APL_EDT    "+((getString("APL_EDT").equals(""))?" is null ":"=")+getString("APL_EDT")+",");
		sql.append("SLS_PRIZ   "+((getString("SLS_PRIZ").equals(""))?" is null ":"=")+getString("SLS_PRIZ")+",");
		sql.append("CUS_PRC_TAB_CN   "+((getString("CUS_PRC_TAB_CN").equals(""))?" is null ":"=")+getString("CUS_PRC_TAB_CN")+",");
		sql.append("UPD_DTTM   = TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDD HH24:MI:SS'),");
		sql.append("UPD_CHRG_CD"+((getString("UPD_CHRG_CD").equals(""))?" is null ":"=")+getString("UPD_CHRG_CD")+",");
		sql.append("UPD_PGID   "+((getString("UPD_PGID").equals(""))?" is null ":"=")+getString("UPD_PGID")+",");
		sql.append("FM_TYP     "+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+" ");
		sql.append("WHERE ");
		sql.append("SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("AND ");
		sql.append("CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("AND ");
		sql.append("ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("APL_BDT			"+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+" ");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int 	UPDATE_M059903(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("	UPDATE M05");
		sql.append("	SET");
		sql.append("	APL_EDT "+((getString("APL_EDT").equals(""))?" is null ":"=")+getString("APL_EDT")+",");
		sql.append("	UPD_DTTM = TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDDHH24MISS'),               ");
		sql.append("    UPD_CHRG_CD "+((getString("UPD_CHRG_CD").equals(""))?" is null ":"=")+getString("UPD_CHRG_CD")+",        ");
		sql.append("    UPD_PGID "+((getString("UPD_PGID").equals(""))?" is null ":"=")+getString("UPD_PGID")+",");
		sql.append("	FM_TYP "+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+"");
		sql.append("	WHERE ");
		sql.append("	SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("	AND ");
		sql.append("	CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("	AND ");
		sql.append("	ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("    AND");
		sql.append("    APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M059904(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("UPDATE ");
		sql.append("M05 ");
		sql.append("SET ");
		sql.append("APL_EDT			"+((getString("APL_EDT").equals(""))?" is null ":"=")+getString("APL_EDT")+",");
		sql.append("UPD_DTTM		=TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDD HH24:MI:SS'),");
		sql.append("UPD_CHRG_CD		"+((getString("UPD_CHRG_CD").equals(""))?" is null ":"=")+getString("UPD_CHRG_CD")+",");
		sql.append("UPD_PGID		"+((getString("UPD_PGID").equals(""))?" is null ":"=")+getString("UPD_PGID")+",");
		sql.append("FM_TYP			"+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+" ");
		sql.append("WHERE ");
		sql.append("SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("AND ");
		sql.append("CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("AND ");
		sql.append("ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("APL_BDT			"+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+" ");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M059905(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("UPDATE ");
		sql.append("M05 ");
		sql.append("SET ");
		sql.append("UPD_DTTM		=TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDD HH24:MI:SS'),");
		sql.append("UPD_CHRG_CD		"+((getString("UPD_CHRG_CD").equals(""))?" is null ":"=")+getString("UPD_CHRG_CD")+",");
		sql.append("UPD_PGID		"+((getString("UPD_PGID").equals(""))?" is null ":"=")+getString("UPD_PGID")+",");
		sql.append("FM_TYP			"+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+" ");
		sql.append("WHERE ");
		sql.append("SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("AND ");
		sql.append("CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("AND ");
		sql.append("ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("APL_BDT			"+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M059906(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("	UPDATE M05");
		sql.append("	SET");
		sql.append("	GNR_ADM_NO "+((getString("GNR_ADM_NO").equals(""))?" is null ":"=")+getString("GNR_ADM_NO")+",");
		sql.append("	UPD_DTTM = TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDDHH24MISS'),               ");
		sql.append("    UPD_CHRG_CD "+((getString("UPD_CHRG_CD").equals(""))?" is null ":"=")+getString("UPD_CHRG_CD")+",        ");
		sql.append("    UPD_PGID "+((getString("UPD_PGID").equals(""))?" is null ":"=")+getString("UPD_PGID")+",");
		sql.append("	FM_TYP "+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+"");
		sql.append("	WHERE ");
		sql.append("		   SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("		   AND ");
		sql.append("		   CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("		   AND ");
		sql.append("		   ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"  ");
		sql.append("		   AND");
		sql.append("		   APL_BDT = (");
		sql.append("		   	SELECT");
		sql.append("			MAX(APL_BDT) AS APL_BDT");
		sql.append("			FROM");
		sql.append("			M05");
		sql.append("			WHERE ");
		sql.append("		   SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("		   AND ");
		sql.append("		   CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("		   AND ");
		sql.append("		   ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("			AND");
		sql.append("			APL_EDT < "+getString("SYSDATE")+"");
		sql.append("			AND");
		sql.append("			FM_TYP <> "+getString("NOT_FM_TYP")+") ");
		sql.append("			");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M059907(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("	UPDATE M05");
		sql.append("	SET");
		sql.append("	APL_EDT "+((getString("APL_EDT").equals(""))?" is null ":"=")+getString("APL_EDT")+",");
		sql.append("	GNR_ADM_NO "+((getString("GNR_ADM_NO").equals(""))?" is null ":"=")+getString("GNR_ADM_NO")+", ");
		sql.append("	UPD_DTTM = TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDDHH24MISS'),               ");
		sql.append("    UPD_CHRG_CD "+((getString("UPD_CHRG_CD").equals(""))?" is null ":"=")+getString("UPD_CHRG_CD")+",        ");
		sql.append("    UPD_PGID "+((getString("UPD_PGID").equals(""))?" is null ":"=")+getString("UPD_PGID")+",");
		sql.append("	FM_TYP "+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+"");
		sql.append("	WHERE ");
		sql.append("		   SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("		   AND ");
		sql.append("		   CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("		   AND ");
		sql.append("		   ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("		   AND");
		sql.append("		   APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int UPDATE_M059908(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("UPDATE M05 ");
		sql.append("SET ");
		sql.append("APL_BDT	   "+((getString("NEW_APL_BDT").equals(""))?" is null ":"=")+getString("NEW_APL_BDT")+",");
		sql.append("SLCP_CD    "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+",");
		sql.append("CUS_CD     "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+",");
		sql.append("ITM_NO     "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+",");
		sql.append("APL_EDT    "+((getString("APL_EDT").equals(""))?" is null ":"=")+getString("APL_EDT")+",");
		sql.append("SLS_PRIZ   "+((getString("SLS_PRIZ").equals(""))?" is null ":"=")+getString("SLS_PRIZ")+",");
		sql.append("CUS_PRC_TAB_CN   "+((getString("CUS_PRC_TAB_CN").equals(""))?" is null ":"=")+getString("CUS_PRC_TAB_CN")+",");
		sql.append("UPD_DTTM   = TO_DATE("+getString("UPD_DTTM")+",'YYYYMMDD HH24:MI:SS'),");
		sql.append("UPD_CHRG_CD"+((getString("UPD_CHRG_CD").equals(""))?" is null ":"=")+getString("UPD_CHRG_CD")+",");
		sql.append("UPD_PGID   "+((getString("UPD_PGID").equals(""))?" is null ":"=")+getString("UPD_PGID")+",");
		sql.append("FM_TYP     "+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+" ");
		sql.append("WHERE ");
		sql.append("SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("AND ");
		sql.append("CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("AND ");
		sql.append("ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("APL_BDT "+((getString("OLD_APL_BDT").equals(""))?" is null ":"=")+getString("OLD_APL_BDT")+" ");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int DELETE_M059901(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("DELETE ");
		sql.append("FROM ");
		sql.append("M05 ");
		sql.append("WHERE ");
		sql.append("SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("AND ");
		sql.append("CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("AND ");
		sql.append("ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("FM_TYP		"+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int DELETE_M059902(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("	DELETE FROM M05");
		sql.append("	WHERE ");
		sql.append("	SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("	AND ");
		sql.append("	CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("	AND");
		sql.append("	ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("	AND ");
		sql.append("	APL_BDT = (");
		sql.append("	SELECT");
		sql.append("	MIN(APL_BDT) AS APL_BDT");
		sql.append("	FROM");
		sql.append("	M05");
		sql.append("	WHERE ");
		sql.append("	SLCP_CD "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("	AND ");
		sql.append("	CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("	AND ");
		sql.append("	ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("	AND");
		sql.append("	FM_TYP <> "+getString("NOT_FM_TYP")+") ");
		sql.append("	");
		sql.append("	");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int INSERT_BM059901(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("INSERT INTO BM05(");
		sql.append("SEQ_NO ,");
		sql.append("SLCP_CD,");
		sql.append("CUS_CD,");
		sql.append("ITM_NO,");
		sql.append("APL_BDT,");
		sql.append("APL_EDT,");
		sql.append("GNR_ADM_NO,");
		sql.append("SLS_PRIZ,");
		sql.append("CUS_PRC_TAB_CN,");
		sql.append("RGS_DTTM,");
		sql.append("RGS_CHRG_CD,");
		sql.append("RGS_PGID,");
		sql.append("UPD_DTTM,");
		sql.append("UPD_CHRG_CD,");
		sql.append("UPD_PGID,");
		sql.append("FM_TYP");
		sql.append(") ");
		sql.append("SELECT ");
		sql.append("SEQ_BM05.NEXTVAL,");
		sql.append("SLCP_CD,");
		sql.append("CUS_CD,");
		sql.append("ITM_NO,");
		sql.append("APL_BDT,");
		sql.append("APL_EDT,");
		sql.append("GNR_ADM_NO,");
		sql.append("SLS_PRIZ,");
		sql.append("CUS_PRC_TAB_CN,");
		sql.append("RGS_DTTM,");
		sql.append("RGS_CHRG_CD,");
		sql.append("RGS_PGID,");
		sql.append("UPD_DTTM,");
		sql.append("UPD_CHRG_CD,");
		sql.append("UPD_PGID,");
		sql.append("FM_TYP ");
		sql.append("FROM M05 ");
		sql.append("WHERE ");
		sql.append("SLCP_CD			"+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("AND ");
		sql.append("CUS_CD			"+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("AND ");
		sql.append("ITM_NO			"+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("APL_BDT			"+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+" ");
		sql.append("	");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int INSERT_BM059902(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("INSERT INTO BM05(");
		sql.append("SEQ_NO ,");
		sql.append("SLCP_CD,");
		sql.append("CUS_CD,");
		sql.append("ITM_NO,");
		sql.append("APL_BDT,");
		sql.append("APL_EDT,");
		sql.append("GNR_ADM_NO,");
		sql.append("SLS_PRIZ,");
		sql.append("CUS_PRC_TAB_CN,");
		sql.append("RGS_DTTM,");
		sql.append("RGS_CHRG_CD,");
		sql.append("RGS_PGID,");
		sql.append("UPD_DTTM,");
		sql.append("UPD_CHRG_CD,");
		sql.append("UPD_PGID,");
		sql.append("FM_TYP");
		sql.append(") ");
		sql.append("SELECT ");
		sql.append("SEQ_BM05.NEXTVAL,");
		sql.append("SLCP_CD,");
		sql.append("CUS_CD,");
		sql.append("ITM_NO,");
		sql.append("APL_BDT,");
		sql.append("APL_EDT,");
		sql.append("GNR_ADM_NO,");
		sql.append("SLS_PRIZ,");
		sql.append("CUS_PRC_TAB_CN,");
		sql.append("RGS_DTTM,");
		sql.append("RGS_CHRG_CD,");
		sql.append("RGS_PGID,");
		sql.append("UPD_DTTM,");
		sql.append("UPD_CHRG_CD,");
		sql.append("UPD_PGID,");
		sql.append("FM_TYP ");
		sql.append("FROM M05 ");
		sql.append("WHERE ");
		sql.append("SLCP_CD			"+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("AND ");
		sql.append("CUS_CD			"+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("AND ");
		sql.append("ITM_NO			"+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND           ");
		sql.append("APL_EDT >=	"+getString("NOWDATE")+" ");
		sql.append("AND ");
		sql.append("FM_TYP <> "+getString("NOT_FM_TYP")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int INSERT_BM059903(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("INSERT INTO BM05(");
		sql.append("SEQ_NO ,");
		sql.append("SLCP_CD,");
		sql.append("CUS_CD,");
		sql.append("ITM_NO,");
		sql.append("APL_BDT,");
		sql.append("APL_EDT,");
		sql.append("GNR_ADM_NO,");
		sql.append("SLS_PRIZ,");
		sql.append("CUS_PRC_TAB_CN,");
		sql.append("RGS_DTTM,");
		sql.append("RGS_CHRG_CD,");
		sql.append("RGS_PGID,");
		sql.append("UPD_DTTM,");
		sql.append("UPD_CHRG_CD,");
		sql.append("UPD_PGID,");
		sql.append("FM_TYP");
		sql.append(") ");
		sql.append("SELECT ");
		sql.append("SEQ_BM05.NEXTVAL,");
		sql.append("SLCP_CD,");
		sql.append("CUS_CD,");
		sql.append("ITM_NO,");
		sql.append("APL_BDT,");
		sql.append("APL_EDT,");
		sql.append("GNR_ADM_NO,");
		sql.append("SLS_PRIZ,");
		sql.append("CUS_PRC_TAB_CN,");
		sql.append("RGS_DTTM,");
		sql.append("RGS_CHRG_CD,");
		sql.append("RGS_PGID,");
		sql.append("UPD_DTTM,");
		sql.append("UPD_CHRG_CD,");
		sql.append("UPD_PGID,");
		sql.append("FM_TYP ");
		sql.append("FROM M05 ");
		sql.append("WHERE ");
		sql.append("SLCP_CD			"+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("AND ");
		sql.append("CUS_CD			"+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("AND ");
		sql.append("ITM_NO			"+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND                     ");
		sql.append("APL_EDT <=	"+getString("NOWDATE")+" ");
		sql.append("AND ");
		sql.append("FM_TYP <> "+getString("NOT_FM_TYP")+"  ");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public int INSERT_BM059904(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("INSERT INTO BM05(");
		sql.append("SEQ_NO ,");
		sql.append("SLCP_CD,");
		sql.append("CUS_CD,");
		sql.append("ITM_NO,");
		sql.append("APL_BDT,");
		sql.append("APL_EDT,");
		sql.append("GNR_ADM_NO,");
		sql.append("SLS_PRIZ,");
		sql.append("CUS_PRC_TAB_CN,");
		sql.append("RGS_DTTM,");
		sql.append("RGS_CHRG_CD,");
		sql.append("RGS_PGID,");
		sql.append("UPD_DTTM,");
		sql.append("UPD_CHRG_CD,");
		sql.append("UPD_PGID,");
		sql.append("FM_TYP");
		sql.append(") ");
		sql.append("SELECT ");
		sql.append("SEQ_BM05.NEXTVAL,");
		sql.append("SLCP_CD,");
		sql.append("CUS_CD,");
		sql.append("ITM_NO,");
		sql.append("APL_BDT,");
		sql.append("APL_EDT,");
		sql.append("GNR_ADM_NO,");
		sql.append("SLS_PRIZ,");
		sql.append("CUS_PRC_TAB_CN,");
		sql.append("RGS_DTTM,");
		sql.append("RGS_CHRG_CD,");
		sql.append("RGS_PGID,");
		sql.append("UPD_DTTM,");
		sql.append("UPD_CHRG_CD,");
		sql.append("UPD_PGID,");
		sql.append("FM_TYP ");
		sql.append("FROM M05 ");
		sql.append("WHERE  ");
		sql.append("SLCP_CD			"+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+" ");
		sql.append("AND ");
		sql.append("CUS_CD			"+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+" ");
		sql.append("AND ");
		sql.append("ITM_NO			"+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+" ");
		sql.append("AND ");
		sql.append("FM_TYP			"+((getString("FM_TYP").equals(""))?" is null ":"=")+getString("FM_TYP")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		int updateCount = db.executeUpdate();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return updateCount;
	}

	public SelectResultRset SELECT_M0512(FrameworkDbCommon db) throws Exception {
		StringBuffer sql = new StringBuffer();
		sql.append("	SELECT");
		sql.append("	COUNT(*) AS COUNTS");
		sql.append("	FROM ");
		sql.append("	M05");
		sql.append("	WHERE");
		sql.append("	SLCP_CD  "+((getString("SLCP_CD").equals(""))?" is null ":"=")+getString("SLCP_CD")+"");
		sql.append("	AND");
		sql.append("	CUS_CD "+((getString("CUS_CD").equals(""))?" is null ":"=")+getString("CUS_CD")+"");
		sql.append("	AND ");
		sql.append("	ITM_NO "+((getString("ITM_NO").equals(""))?" is null ":"=")+getString("ITM_NO")+"");
		sql.append("	AND");
		sql.append("	APL_BDT "+((getString("APL_BDT").equals(""))?" is null ":"=")+getString("APL_BDT")+"");
		sql.append("	AND");
		sql.append("	TO_CHAR(NVL(UPD_DTTM,''),'YYYYMMDDHH24MISS') "+((getString("UPD_DTTM").equals(""))?" is null ":"=")+getString("UPD_DTTM")+"");
		db.setSql(sql.toString());
		lastSql_ =sql.toString();
		SelectResultRset srr = db.executeQuery();
		paramsString     = new Hashtable();
		paramsBigDecimal = new Hashtable();
		paramsFree       = new Hashtable();

		return srr;
	}


	public void setSLCP_CD(String value){
		if(value==null) {
			paramsString.remove("SLCP_CD");
			return;
		}
		paramsString.put("SLCP_CD",value);
	}


	public void setCUS_CD(String value){
		if(value==null) {
			paramsString.remove("CUS_CD");
			return;
		}
		paramsString.put("CUS_CD",value);
	}


	public void setITM_NO(String value){
		if(value==null) {
			paramsString.remove("ITM_NO");
			return;
		}
		paramsString.put("ITM_NO",value);
	}


	public void setAPL_BDT(String value){
		if(value==null) {
			paramsString.remove("APL_BDT");
			return;
		}
		paramsString.put("APL_BDT",value);
	}


	public void setAPL_EDT(String value){
		if(value==null) {
			paramsString.remove("APL_EDT");
			return;
		}
		paramsString.put("APL_EDT",value);
	}


	public void setGNR_ADM_NO(String value){
		if(value==null) {
			paramsString.remove("GNR_ADM_NO");
			return;
		}
		paramsString.put("GNR_ADM_NO",value);
	}


	public void setCUS_PRC_TAB_CN(String value){
		if(value==null) {
			paramsString.remove("CUS_PRC_TAB_CN");
			return;
		}
		paramsString.put("CUS_PRC_TAB_CN",value);
	}


	public void setRGS_DTTM(String value){
		if(value==null) {
			paramsString.remove("RGS_DTTM");
			return;
		}
		paramsString.put("RGS_DTTM",value);
	}


	public void setRGS_CHRG_CD(String value){
		if(value==null) {
			paramsString.remove("RGS_CHRG_CD");
			return;
		}
		paramsString.put("RGS_CHRG_CD",value);
	}


	public void setRGS_PGID(String value){
		if(value==null) {
			paramsString.remove("RGS_PGID");
			return;
		}
		paramsString.put("RGS_PGID",value);
	}


	public void setUPD_DTTM(String value){
		if(value==null) {
			paramsString.remove("UPD_DTTM");
			return;
		}
		paramsString.put("UPD_DTTM",value);
	}


	public void setUPD_CHRG_CD(String value){
		if(value==null) {
			paramsString.remove("UPD_CHRG_CD");
			return;
		}
		paramsString.put("UPD_CHRG_CD",value);
	}


	public void setUPD_PGID(String value){
		if(value==null) {
			paramsString.remove("UPD_PGID");
			return;
		}
		paramsString.put("UPD_PGID",value);
	}


	public void setFM_TYP(String value){
		if(value==null) {
			paramsString.remove("FM_TYP");
			return;
		}
		paramsString.put("FM_TYP",value);
	}


	public void setTEMP_APL(String value){
		if(value==null) {
			paramsString.remove("TEMP_APL");
			return;
		}
		paramsString.put("TEMP_APL",value);
	}


	public void setFM(String value){
		if(value==null) {
			paramsString.remove("FM");
			return;
		}
		paramsString.put("FM",value);
	}


	public void setTEMPDATE(String value){
		if(value==null) {
			paramsString.remove("TEMPDATE");
			return;
		}
		paramsString.put("TEMPDATE",value);
	}


	public void setFM9(String value){
		if(value==null) {
			paramsString.remove("FM9");
			return;
		}
		paramsString.put("FM9",value);
	}


	public void setFM6(String value){
		if(value==null) {
			paramsString.remove("FM6");
			return;
		}
		paramsString.put("FM6",value);
	}


	public void setDATE9999(String value){
		if(value==null) {
			paramsString.remove("DATE9999");
			return;
		}
		paramsString.put("DATE9999",value);
	}


	public void setFM8(String value){
		if(value==null) {
			paramsString.remove("FM8");
			return;
		}
		paramsString.put("FM8",value);
	}


	public void setENDDATE(String value){
		if(value==null) {
			paramsString.remove("ENDDATE");
			return;
		}
		paramsString.put("ENDDATE",value);
	}


	public void setCTRL_DVSN_CD(String value){
		if(value==null) {
			paramsString.remove("CTRL_DVSN_CD");
			return;
		}
		paramsString.put("CTRL_DVSN_CD",value);
	}


	public void setTRPT_CLSS_D_TYP(String value){
		if(value==null) {
			paramsString.remove("TRPT_CLSS_D_TYP");
			return;
		}
		paramsString.put("TRPT_CLSS_D_TYP",value);
	}


	public void setSLS_PRIZ(String value){
		if(value==null) {
			paramsString.remove("SLS_PRIZ");
			return;
		}
		paramsString.put("SLS_PRIZ",value);
	}


	public void setNOT_FM_TYP(String value){
		if(value==null) {
			paramsString.remove("NOT_FM_TYP");
			return;
		}
		paramsString.put("NOT_FM_TYP",value);
	}


	public void setFM_TYP_9(String value){
		if(value==null) {
			paramsString.remove("FM_TYP_9");
			return;
		}
		paramsString.put("FM_TYP_9",value);
	}


	public void setFM_TYP_6(String value){
		if(value==null) {
			paramsString.remove("FM_TYP_6");
			return;
		}
		paramsString.put("FM_TYP_6",value);
	}


	public void setFM_TYP1(String value){
		if(value==null) {
			paramsString.remove("FM_TYP1");
			return;
		}
		paramsString.put("FM_TYP1",value);
	}


	public void setFM_TYP2(String value){
		if(value==null) {
			paramsString.remove("FM_TYP2");
			return;
		}
		paramsString.put("FM_TYP2",value);
	}


	public void setSYSDATE(String value){
		if(value==null) {
			paramsString.remove("SYSDATE");
			return;
		}
		paramsString.put("SYSDATE",value);
	}


	public void setNEW_APL_BDT(String value){
		if(value==null) {
			paramsString.remove("NEW_APL_BDT");
			return;
		}
		paramsString.put("NEW_APL_BDT",value);
	}


	public void setOLD_APL_BDT(String value){
		if(value==null) {
			paramsString.remove("OLD_APL_BDT");
			return;
		}
		paramsString.put("OLD_APL_BDT",value);
	}


	public void setNOWDATE(String value){
		if(value==null) {
			paramsString.remove("NOWDATE");
			return;
		}
		paramsString.put("NOWDATE",value);
	}


	public void setSLS_PRIZ(BigDecimal value){
		if(value==null) {
			paramsBigDecimal.remove("SLS_PRIZ");
			return;
		}
		paramsBigDecimal.put("SLS_PRIZ",value);
	}


	public void setOTHERS_FREE(String value){
		if(value==null) {
			paramsFree.remove("OTHERS");
			return;
		}
		paramsFree.put("OTHERS",value);
	}


}
